USE [ANTS_NetServer]
GO

/****** Object:  StoredProcedure [dbo].[proc_DeviceInfo_t_insert]    Script Date: 04/21/2013 15:24:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


create proc [dbo].[proc_DeviceInfo_t_insert]
(
    @DeviceID  int,
    @LocalIpv4  nvarchar(100),
    @Port  nvarchar(100),
    @Mac  nvarchar(100),
    @Sn  nvarchar(100),
    @ServerIP  nvarchar(100),
    @ServerPort  nvarchar(100),
    @DeviceName  nvarchar(100),
    @DeviceDomain  nvarchar(100),
    @RegistTime  datetime,
    @Remark  nvarchar(100),
    @DeviceStatus  int,
    @Handle  nvarchar(100),
    @ChanNum  int,
    @StartChan  int,
    @RemoteIPv4  nvarchar(100),
    @RemotePort  nvarchar(100),
    @RegisterID  int,
    @IsCenterPreveiw  int,
    @STSServerIP  nvarchar(100),
    @STSServerPort  nvarchar(100),
    @STSServeIsUse  int
)
as 
insert into DeviceInfo_t
(
    DeviceID,
    LocalIpv4,
        Port,
        Mac,
        Sn,
        ServerIP,
        ServerPort,
        DeviceName,
        DeviceDomain,
        RegistTime,
        Remark,
        DeviceStatus,
        Handle,
        ChanNum,
        StartChan,
        RemoteIPv4,
        RemotePort,
        RegisterID,
        IsCenterPreveiw,
        STSServerIP,
        STSServerPort,
        STSServeIsUse
    )
values
(
    @DeviceID,
    @LocalIpv4,
    @Port,
    @Mac,
    @Sn,
    @ServerIP,
    @ServerPort,
    @DeviceName,
    @DeviceDomain,
    @RegistTime,
    @Remark,
    @DeviceStatus,
    @Handle,
    @ChanNum,
    @StartChan,
    @RemoteIPv4,
    @RemotePort,
    @RegisterID,
    @IsCenterPreveiw,
    @STSServerIP,
    @STSServerPort,
    @STSServeIsUse
)
GO


